-- this sproc cannot create #temp tables because it can be called in chained mode
use common
go

if exists (select 1 from sysobjects where name = "p_GetNodeDetails")
begin
        drop proc p_GetNodeDetails
end
go

create proc p_GetNodeDetails 
( 
	
	@CuId		int=0
)  
  
as  
begin  
  
	-- declare  
	declare @ErrVal		int		-- last error number  
	declare @Msg		char(255) -- Err message  

		select a.*
		from common..t_ReleaseObjects a
		where CuId = @CuId 
	return  
  
ErrorHandler:  
	raiserror @ErrVal @Msg  
end                                                                                                                                                                            
go

sp_procxmode "p_GetNodeDetails","anymode"
go

grant all on p_GetNodeDetails to public
go


